UCSF

Parameters Provided:

name.synonym = 15-Apo-beta-caroten-15-oate;15-Apo-beta-caroten-15-oic acid;9-cis-Retinoate;9-cis-Retinoic acid;9-cis-Tretinoin;9-Retinoate;9-Retinoic acid;A-Acido (argentina);Aberel;Aberela [norway];Acide retinoique (french) (DSL);Airol;Aknoten;Alitretinoin;Alitretinoin
filter.purchasability = all
page.num = 1

Structural Results Found: (before additional filtering)

SQL Query Was

SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id INNER JOIN synonym AS syn ON (ci.cat_id_fk=syn.cat_fk AND ci.supplier_code=syn.supplier_code) INNER JOIN field AS f ON syn.field_fk=f.field_id  WHERE c.free = 1 AND syn.synonym IS NOT NULL AND syn.synonym LIKE '15-Apo-beta-caroten-15-oate;15-Apo-beta-caroten-15-oic acid;9-cis-Retinoate;9-cis-Retinoic acid;9-cis-Tretinoin;9-Retinoate;9-Retinoic acid;A-Acido (argentina);Aberel;Aberela [norway];Acide retinoique (french) (DSL);Airol;Aknoten;Alitretinoin;Alitretinoin' AND f.ftype IN (3,7,11,12,14) AND ci.sub_id_fk IN (SELECT ci.sub_id_fk AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id  WHERE c.free = 1   )    LIMIT 50

Permalink

//zinc12.docking.org/results/combination?name.synonym=15-Apo-beta-caroten-15-oate%3B15-Apo-beta-caroten-15-oic+acid%3B9-cis-Retinoate%3B9-cis-Retinoic+acid%3B9-cis-Tretinoin%3B9-Retinoate%3B9-Retinoic+acid%3BA-Acido+%28argentina%29%3BAberel%3BAberela+%5Bnorway%5D%3BAcide+retinoique+%28french%29+%28DSL%29%3BAirol%3BAknoten%3BAlitretinoin%3BAlitretinoin&filter.purchasability=all

Embed Link to Results